package cn.edu.dao;

import cn.edu.domain.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author:David chan
 * @data:2022/8/5
 */
@Mapper
public interface User_login {

    @Select("select * from col_staff where id=#{id} and password=#{password}")
    User Col_login(@Param("id") int id,@Param("password") String password);

    @Select("select * from dep_staff where id=#{id} and password=#{password}")
    User Dep_login(@Param("id") int id,@Param("password") String password);

    @Select("select * from lead_staff where id=#{id} and password=#{password}")
    User Lead_login(@Param("id") int id,@Param("password") String password);
}
